Star Smash - Squadron Organizer

Star Smash - Squadron Organizer

The Squadron Organizer is an Excel spreadsheet used to select ships for the squadrons in the tournament.

The current version of the Squadron Organizer is 1.8.

Download Squadron Organizer 1.8 (.zip, 47K)

Download Squadron Organizer 1.8 (.xls, 54K)

Changes in Version 1.8:

Removed the illegal Klingon D-18D Gull destroyer.
Added the replacement Klingon D-18E Gull destroyer.

Changes in Version 1.7:

Added the Romulan V-33 Condor Type 3 cruiser.

Changes in Version 1.6:

Added the Romulan V-33 Condor Type 2 cruiser.

Changes in Version 1.5:

Forgot to update the formulas in the lines added back in.

Changes in Version 1.4:

Put back the three lines for ships which were removed in Version 1.3 by ... accident ... right ... accident.

Changes in Version 1.3:

Put a rounding function in the "Modified CE / Total" column to correct a minor adding error (incorrect rounding could cause a squadron's total CE to be up to 0.3 less than it should have been).
Added the new Federation Dianna Mk I class of Light Cruiser.
Changed the Romulan "T-2 Death Talon 5" to the correct designation of "T-2 Death Talon 7" and "T-2 Death Talon 7 NC".

Changes in Version 1.2:

Fixed the name for the "D-19B Viper's Tongue" without a cloak to "D-19B Viper's Tongue NC".
Fixed the "Excess CE:" line to actually display the Excess CE.

Using The Squadron Organizer

Preparation

    Before starting to organize a squadron, you may want to have the Master Ship Listing available (either the Excel file or the on-line version). Use it as a reference for selecting ships. You may also want to have access to the design information (the Designs section of this site, and the STSSTC - Millennium Update & Archive).

Select Nation

    Indicate the nationality of the squadron by placing an "x" (or almost anything) in one of the white boxes at the upper left of the spreadsheet.

Select Ships

    Select each of the ships to be included in the squadron. Type the complete name of the ship or copy and paste the name from the other tabs in the Squadron Organizer file.

Selection Errors

    If any Red information is displayed on the spreadsheet, you have an error and need to change your selection(s) to remove the illegal condition.

Entry Errors

    If any of the computed data (light gray areas) display non-numeric values such as "N/A", "Value", or "##", then you have made an entry error. Check to see that you have selected a nation and that the ships entered are correct for the nation selected.

Download Squadron Organizer 1.8 (.zip, 47K)
Download Squadron Organizer 1.8 (.xls, 54K)

Preparation
	Before starting to organize a squadron, you may want to have the Master Ship Listing available (either the Excel file or the on-line version). Use it as a reference for selecting ships. You may also want to have access to the design information (the Designs section of this site, and the STSSTC - Millennium Update & Archive).
Select Nation
	Indicate the nationality of the squadron by placing an "x" (or almost anything) in one of the white boxes at the upper left of the spreadsheet.
Select Ships
	Select each of the ships to be included in the squadron. Type the complete name of the ship or copy and paste the name from the other tabs in the Squadron Organizer file.
Selection Errors
	If any Red information is displayed on the spreadsheet, you have an error and need to change your selection(s) to remove the illegal condition.
Entry Errors
	If any of the computed data (light gray areas) display non-numeric values such as "N/A", "Value", or "##", then you have made an entry error. Check to see that you have selected a nation and that the ships entered are correct for the nation selected.